select max(a.salary) as ms,a.dept_name
from instructor a
group by dept_name;